CDC for Microsoft SQL Server using Routes and Queues

 

Open solution

 

Category

Microsoft

Prerequisites

Talend ESB Basics, Talend ESB Administration

Third-party software

Microsoft SQL server with CDC

Description

 

 

Talend offers several components for managing Change Data Capture (CDC) for a wide range of enterprise relational databases. To help companies manage the increasing necessity of making changes in real time (or near real time) it can be helpful to adopt a strategy based on Enterprise Service Bus (ESB) instead of the classical approach based on batch Jobs. This solution template shows you how to implement a fully functional CDC framework for Microsoft SQL Server and dynamically push the incremental changes in a message queue, such as Active MQ.